<?php if(!defined('PATH_HD'))exit;
$db->exe("DROP TABLE IF EXISTS `hd_news`");
$db->exe("CREATE TABLE `hd_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL COMMENT '文章标题',
  `click` int(11) NOT NULL COMMENT '点击次数',
  `gourl` varchar(100) NOT NULL COMMENT '跳转url',
  `keywords` varchar(100) NOT NULL COMMENT '关键字',
  `description` varchar(200) NOT NULL COMMENT '描述',
  `addtime` int(10) NOT NULL COMMENT '发布时间',
  `updatetime` int(10) NOT NULL COMMENT '修改时间',
  `thumb` varchar(100) NOT NULL COMMENT '缩略图',
  `recycled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '回收站',
  `catid` smallint(6) NOT NULL,
  `uid` int(11) NOT NULL COMMENT '用户ID\n',
  PRIMARY KEY (`id`),
  KEY `fk_hd_news_hd_category` (`catid`),
  KEY `fk_hd_news_hd_user1` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COMMENT='文章表'");
$db->exe('REPLACE INTO `hd_news`(`id`,`title`,`click`,`gourl`,`keywords`,`description`,`addtime`,`updatetime`,`thumb`,`recycled`,`catid`,`uid`)VALUES ("103","1","100","","SDF","DSF","1351012827","1351012827","","0","110","15")');
$db->exe('REPLACE INTO `hd_news`(`id`,`title`,`click`,`gourl`,`keywords`,`description`,`addtime`,`updatetime`,`thumb`,`recycled`,`catid`,`uid`)VALUES ("104","2","100","","SDF","SDF","1351012834","1351012834","","0","110","15")');
$db->exe('REPLACE INTO `hd_news`(`id`,`title`,`click`,`gourl`,`keywords`,`description`,`addtime`,`updatetime`,`thumb`,`recycled`,`catid`,`uid`)VALUES ("105","3","100","","","dsd","1351014110","1351014110","","0","110","15")');

?>